Hello

In [1]:
import cufflinks as cf
import pandas as pd
import numpy as np

import plotly.offline as py
import plotly.graph_objs as go

from IPython.display import display, Markdown, Latex

py.init_notebook_mode(connected=True)

cf.set_config_file(offline=True)
In [2]:
dtype = {'County': np.str,
         'Employee Name': np.str,
         'Job Title': np.str,
         'Year': np.int64,
         'Notes': np.str,
         'Agency': np.str,
         'Status': np.str}


def to_float(x):
    try:
        return float(x)
    except Exception as e:
        return None


converters = {'Base Pay': to_float,
              'Overtime Pay': to_float,
              'Other Pay': to_float,
              'Benefits': to_float,
              'Total Pay': to_float,
              'Total Pay & Benefits': to_float}

df = pd.read_csv("data.csv.gz", compression='gzip', dtype=dtype, converters=converters)
In [3]:
def get_df(county, entity, year):
    return df[(df['County'] == county) & 
              (df['Job Title'].str.contains("(?i){entity}".format(entity=entity))) & 
              (df['Year'] == year)] 

def display_mean_salary_by_year(county, entity, year):
    ga = get_df(county, entity, year).groupby(['Agency'])['Total Pay & Benefits']
    ga_mean = ga.mean()
    ga_mean = ga_mean.to_frame().reset_index().sort_values(by='Total Pay & Benefits', ascending=False)
    ga_mean.iplot(title='{county}, {entity}, Mean Salary - {year}'.format(county=county, 
                                                                          entity=entity, 
                                                                          year=year), 
                  x='Agency', kind='bar', filename='cufflinks/grouped-bar-chart')
    display(ga.describe().sort_values(by='mean', ascending=False))


YEARS = [2016, 2015, 2014, 2013, 2012]
COUNTIES = ['San Mateo County']
ENTITIES = ['teacher', 'principal']

for county in COUNTIES:
    for entity in ENTITIES:
        display(Markdown('# {county}, {entity}, Mean Salary in {year_from} - {year_to}'.format(county=county,
                                                                                             entity=entity,
                                                                                             year_from=min(YEARS),
                                                                                             year_to=max(YEARS))))
        for year in YEARS:
            display_mean_salary_by_year(county, entity, year)

San Mateo County, teacher, Mean Salary in 2012 - 2016

count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 51.0 114308.219020 35249.918013 24441.29 103155.8500 121072.10 141348.2650 155939.98
Las Lomitas Elementary 86.0 112186.286860 34589.274925 17674.21 101644.4400 124789.11 135003.1050 162679.42
Menlo Park City Elementary 197.0 109100.831675 31872.646527 4772.96 93540.9600 120378.59 132307.0000 149728.85
San Mateo Union High 516.0 89637.898624 55348.637580 0.00 43487.9725 110342.98 136326.1075 177103.02
Redwood City Elementary 414.0 84091.860145 30399.758222 3467.76 66821.5800 90014.50 108050.1200 130262.17
San Mateo County Office of Education 98.0 81386.744898 51924.932731 161.00 34584.7500 87253.00 130387.5000 162407.00
San Mateo-Foster City 671.0 80915.340134 34628.192956 0.00 56369.8450 88089.60 109455.3500 130813.29
San Carlos Elementary 179.0 80820.370000 30054.581153 10515.54 62665.3750 93103.93 101742.9000 118654.71
Belmont-Redwood Shores Elementary 212.0 80434.726415 30277.630425 1.00 63843.0000 84095.00 104613.7500 141135.00
Pacifica School District 166.0 78638.991265 31585.521205 0.00 56373.2525 88943.20 105053.9350 126200.80
South San Francisco Unified 361.0 76595.146814 26264.206634 0.00 65551.0000 79782.00 96918.0000 127910.00
Burlingame Elementary 184.0 74049.296196 27328.244889 4156.15 54526.6300 77799.64 96986.4500 116783.89
Bayshore Elementary 23.0 71390.652174 24179.923018 23153.00 64017.0000 76141.00 85656.5000 102482.00
La Honda-Pescadero Unified 38.0 66914.996579 30181.638608 24.70 47218.5150 72050.93 87400.4625 124795.88
count mean std min 25% 50% 75% max
Agency
San Mateo Union High 388.0 117053.419407 38169.116191 1199.06 97240.6825 129096.210 146170.9600 195573.51
Menlo Park City Elementary 210.0 106634.159810 38686.061510 1314.29 85142.0375 121874.850 136013.6300 152600.47
Woodside Elementary 39.0 105741.350000 32786.614038 35032.81 85672.0350 115348.250 127850.4250 165303.09
Hillsborough City Elementary 135.0 105162.210370 36274.898210 14200.68 82639.9600 117400.880 132841.8800 156858.61
San Carlos Elementary 180.0 83407.442056 27958.945131 466.41 71778.0475 93333.765 103788.5975 120869.68
San Mateo-Foster City 629.0 83212.395008 29649.920508 0.00 66751.6200 90426.970 106376.2700 130413.40
Cabrillo Unified 184.0 81777.165978 34833.832782 881.28 62324.3800 85248.490 110965.5075 151335.71
South San Francisco Unified 462.0 79156.752078 26248.529575 7958.79 66955.5950 84441.055 100269.8175 134160.62
Jefferson Elementary 352.0 78553.438267 29733.544352 1159.30 62450.7850 85683.545 101899.6775 130453.74
Las Lomitas Elementary 147.0 76413.640408 60059.383481 0.00 5274.0450 96178.840 131790.1800 164809.81
Pacifica School District 167.0 74941.960838 32807.893235 279.69 44251.4650 84648.410 102492.5250 124831.43
Millbrae Elementary 145.0 72698.632207 31377.970924 1219.43 42626.0000 78673.190 100827.2700 122979.02
La Honda-Pescadero Unified 37.0 72450.631351 33348.148371 66.35 60311.7900 80146.950 92991.6200 129516.80
Belmont-Redwood Shores Elementary 293.0 62663.578669 44117.376622 75.50 17713.8200 70308.950 101781.4100 138947.88
Redwood City Elementary 683.0 58250.725256 40445.781841 0.00 18701.5100 59961.680 97720.3450 127244.90
Bayshore Elementary 26.0 57759.400769 28857.414005 3612.80 34075.6750 65248.930 75227.9475 103615.24
Burlingame Elementary 289.0 52548.259758 39689.071425 0.00 10129.9100 52903.210 91831.6400 115200.73
count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 52.0 105835.640962 37843.494669 19043.07 84528.1450 118646.980 136825.6275 150799.05
San Mateo Union High 416.0 103967.956082 39288.931495 0.00 79755.1200 116578.340 134148.1225 174815.47
Menlo Park City Elementary 186.0 100413.679355 29965.087940 11063.51 84839.6175 111633.745 122127.9225 155511.51
Hillsborough City Elementary 121.0 100334.018099 32384.399559 2340.89 84872.4300 112626.720 124116.3900 143246.43
San Mateo County Office of Education 103.0 87739.738835 39363.815048 395.31 66196.7950 107152.760 119103.0500 136965.99
Jefferson Elementary 332.0 76217.283343 25110.283448 3763.12 63432.5300 82794.685 95520.4375 119883.27
Belmont-Redwood Shores Elementary 217.0 74392.099355 30452.177747 3774.79 49936.4900 80745.930 100871.8900 126241.04
Redwood City Elementary 495.0 74273.028343 30093.956590 351.67 48675.1450 77395.720 99867.0950 121788.88
Brisbane Elementary 37.0 73454.801081 28064.801734 11053.65 50678.8100 85438.750 94788.6700 118708.63
Pacifica School District 165.0 73329.545758 31912.636493 678.11 44900.9200 83471.820 100356.1400 121840.67
Ravenswood City Elementary 197.0 71128.684619 25138.881238 0.00 56524.6700 73807.540 88427.7300 115228.80
Millbrae Elementary 139.0 71015.978201 30785.372272 17.22 46388.6500 78047.890 96976.9750 119780.36
Las Lomitas Elementary 148.0 69855.697703 53580.997176 160.59 7628.1150 78512.025 120401.0125 150214.89
San Carlos Elementary 166.0 67331.713735 20636.466296 7099.70 56748.8775 72876.010 81953.3250 92283.37
Jefferson Union High 307.0 67162.868013 36646.405483 787.85 36045.0050 73695.530 96644.9100 139596.81
San Bruno Park Elementary 127.0 67075.628976 22418.212869 10196.68 54798.2050 72355.320 83035.3600 102585.78
San Mateo-Foster City 689.0 66616.075849 39514.742097 0.00 29700.6700 74407.940 98813.2800 146467.25
La Honda-Pescadero Unified 39.0 65014.450000 30052.891996 12498.98 37932.8850 63799.980 91097.8600 111784.48
Burlingame Elementary 300.0 47605.959067 39188.397976 66.00 3930.7500 47564.800 84949.2275 109924.81
count mean std min 25% 50% 75% max
Agency
San Mateo Union High 438.0 106746.377466 32364.589033 6441.78 91408.7975 118055.935 130396.8425 168120.68
Menlo Park City Elementary 185.0 105104.414703 30059.186691 24090.59 94554.8200 115788.830 126987.8800 153199.80
Portola Valley Elementary 51.0 100642.726078 32682.519865 27403.30 83698.2400 111475.080 127329.1850 142243.51
Woodside Elementary 42.0 91489.523333 35015.897871 27239.60 61736.5725 105456.310 119330.6000 153219.27
Sequoia Union High 561.0 90095.171961 42362.880521 137.12 53709.9600 103786.260 125135.6000 156745.76
San Mateo County Office of Education 107.0 86761.852991 43038.564355 172.39 46162.7700 108267.940 119327.4400 136325.97
Brisbane Elementary 31.0 77818.666774 18070.359894 18839.57 71261.1650 81433.830 87380.9600 105451.17
San Carlos Elementary 161.0 76820.162298 25046.030843 10598.42 63564.8700 82375.410 97196.7100 112622.01
Redwood City Elementary 449.0 75288.017951 25819.079886 1834.92 60152.6300 81916.510 96344.2400 116783.84
Cabrillo Unified 183.0 75205.049508 36026.067850 110.00 49244.5700 87243.610 104155.5400 142403.74
Belmont-Redwood Shores Elementary 205.0 73109.070537 30021.014470 2665.76 59466.5200 80115.690 97904.8800 123762.26
Jefferson Elementary 305.0 71644.482197 21574.008981 4925.83 58902.8600 77942.150 88039.2900 109289.78
San Mateo-Foster City 602.0 71214.452957 26121.344440 583.81 57438.8500 77823.610 91047.5850 112736.83
Las Lomitas Elementary 143.0 70782.838811 54023.507918 95.44 7836.5850 81882.300 122727.0400 152121.77
South San Francisco Unified 468.0 70256.048098 24695.864975 958.73 60398.0325 75477.730 89180.5775 122537.33
Pacifica School District 161.0 70103.760311 28779.303537 4844.49 53541.3900 78631.270 93947.8200 114053.43
Millbrae Elementary 126.0 69823.920714 27954.430841 5995.26 52522.7425 79981.635 94162.4125 112745.96
Burlingame Elementary 174.0 68961.492241 26729.159614 16394.88 46036.7975 74302.805 91756.5450 112808.86
Ravenswood City Elementary 213.0 65991.920563 26802.787115 2211.88 41526.0000 71886.560 85880.9700 111852.33
Hillsborough City Elementary 200.0 57354.300750 48936.884226 67.50 2530.3700 55736.105 108284.9700 140377.22
Jefferson Union High 320.0 55105.377406 37056.504768 3.64 16885.6475 64265.885 86367.0700 125814.87
La Honda-Pescadero Unified 42.0 51679.879524 30051.522997 1745.12 26156.1975 53969.835 74093.1175 108244.30
Bayshore Elementary 33.0 39379.459394 31633.674839 135.31 5022.8000 33913.540 63776.9000 97785.69
count mean std min 25% 50% 75% max
Agency
Redwood City Elementary 1.0 106291.190000 NaN 106291.19 106291.1900 106291.190 106291.1900 106291.19
Portola Valley Elementary 51.0 103730.362745 36416.987905 12196.40 82261.1500 116476.300 131327.4600 147461.64
San Mateo Union High 448.0 102353.300915 32984.911957 219.40 85361.6225 114449.705 126636.8550 161873.28
Menlo Park City Elementary 175.0 98317.483029 27246.940768 16259.12 86321.9850 107683.840 118193.4350 138092.83
Sequoia Union High 463.0 97190.923866 31663.120873 2369.70 76728.0050 106057.000 121067.1750 152706.34
San Mateo County Office of Education 107.0 82472.189626 39042.438816 1442.17 61257.5350 101141.140 112090.6600 125511.89
Belmont-Redwood Shores Elementary 192.0 75600.078854 29794.200287 389.37 61106.5650 82535.865 100154.5525 120567.44
Millbrae Elementary 118.0 73237.939492 25669.150838 1129.65 59877.6925 82400.920 93143.4775 110617.36
South San Francisco Unified 475.0 71240.390589 23378.121732 3571.38 61071.0700 75791.690 89006.5850 123700.60
Jefferson Elementary 294.0 70895.214456 20457.987967 8.75 59641.2225 76396.025 86299.9850 104356.13
Pacifica School District 1.0 68010.680000 NaN 68010.68 68010.6800 68010.680 68010.6800 68010.68
Burlingame Elementary 168.0 67966.885774 23658.297316 124.49 52334.5025 72235.185 88342.0475 105432.58
Las Lomitas Elementary 140.0 66225.797357 52224.619640 121.74 4074.0750 76045.210 117819.3975 143552.72
San Mateo-Foster City 582.0 65746.562835 24875.457653 5265.89 47096.5850 72331.055 86252.9600 104866.65
Jefferson Union High 254.0 64031.084449 23561.854697 22.25 50859.1050 67971.275 81681.2000 121476.34
Ravenswood City Elementary 212.0 58770.823774 25177.607995 154.22 36492.7050 65393.615 77108.3975 100902.64
Hillsborough City Elementary 197.0 57593.772893 48096.593626 60.00 2617.6000 65825.390 106352.1000 136499.81
Woodside Elementary 69.0 56385.008116 49752.682222 159.06 2505.8000 57991.670 104225.3000 145463.08
San Carlos Elementary 229.0 56255.927991 39349.962461 43.71 9461.0900 68216.610 91471.2100 114395.08
La Honda-Pescadero Unified 37.0 53344.679459 27025.285021 2578.48 31291.4900 61565.280 70151.4500 97885.36
Bayshore Elementary 30.0 39795.116667 31961.471661 125.00 2765.6250 49401.620 65832.0200 95778.24

San Mateo County, principal, Mean Salary in 2012 - 2016

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 19.0 186014.068421 41554.803354 83340.30 172814.8900 187869.990 212029.5150 239112.31
Menlo Park City Elementary 9.0 165147.907778 23216.801901 140584.95 147325.8700 155081.060 180176.3100 200232.08
San Mateo-Foster City 33.0 160677.804242 44687.418499 43060.05 131534.8800 183233.330 191229.6700 205413.54
Burlingame Elementary 10.0 145156.330000 18097.761591 111612.22 133611.8700 143442.185 158919.0800 172007.33
Portola Valley Elementary 3.0 138096.876667 82832.511558 42479.98 113158.0300 183836.080 185905.3250 187974.57
Pacifica School District 10.0 135450.893000 29697.436489 79102.68 133327.4175 146118.630 153671.6425 162938.29
Redwood City Elementary 27.0 134345.885185 36362.904507 64276.06 117770.2150 146939.620 161811.7200 171994.80
Belmont-Redwood Shores Elementary 9.0 133671.777778 33199.366115 78340.00 116840.0000 147579.000 151459.0000 167230.00
Las Lomitas Elementary 5.0 133323.282000 40873.042355 64856.23 127825.3600 149181.400 158857.1400 165896.28
San Carlos Elementary 8.0 126029.747500 47083.167869 11095.54 134939.9025 138932.845 145274.4025 156567.63
San Mateo County Office of Education 6.0 120280.000000 68928.247948 307.00 93180.5000 156017.500 161391.7500 173920.00
South San Francisco Unified 21.0 118872.190476 44580.528660 0.00 72334.0000 141216.000 144639.0000 169704.00
La Honda-Pescadero Unified 3.0 96909.350000 40593.021953 50338.65 82966.0850 115593.520 120194.7000 124795.88
Bayshore Elementary 2.0 96493.500000 59352.421892 54525.00 75509.2500 96493.500 117477.7500 138462.00
count mean std min 25% 50% 75% max
Agency
San Mateo Union High 19.0 177196.006316 50945.533308 83158.91 161453.3050 186167.560 213541.5150 239972.50
San Mateo-Foster City 32.0 169795.223125 31537.536297 82381.96 166983.1325 183739.540 188109.6950 197343.35
Hillsborough City Elementary 4.0 165782.157500 50980.912728 89546.44 163340.9650 188377.550 190818.7425 196827.09
Woodside Elementary 2.0 165410.615000 3362.851359 163032.72 164221.6675 165410.615 166599.5625 167788.51
Las Lomitas Elementary 6.0 143059.295000 50821.356825 64807.13 111643.4675 160733.300 176021.8100 195683.87
San Carlos Elementary 7.0 140336.004286 32989.198564 65947.53 150407.1350 151407.200 151861.6900 160459.65
Burlingame Elementary 9.0 137846.013333 43837.549136 60098.64 141060.9200 158731.970 163974.6800 171233.85
Redwood City Elementary 26.0 137550.526538 40295.257546 14975.72 132435.0925 151675.065 164450.6225 172164.09
Menlo Park City Elementary 10.0 135874.232000 56102.523391 55475.89 80450.5225 158968.130 171652.1050 200525.14
Belmont-Redwood Shores Elementary 10.0 133407.591000 55125.660838 1480.75 139859.2950 156494.035 165557.8025 171243.19
Pacifica School District 10.0 126106.621000 33906.266195 64211.49 104508.3675 141512.015 149916.9350 159419.51
La Honda-Pescadero Unified 3.0 123561.603333 5630.044762 118325.88 120584.0050 122842.130 126179.4650 129516.80
Cabrillo Unified 12.0 123013.089167 34362.644020 57603.29 96715.6525 139410.965 147405.4425 160910.12
South San Francisco Unified 24.0 121688.452083 35782.230750 37939.40 99966.2525 135713.240 144172.1000 173729.02
Jefferson Elementary 22.0 117413.223636 45141.946365 11055.74 77244.6450 140587.095 153125.3675 163498.60
Millbrae Elementary 9.0 89039.873333 42548.451478 48777.38 56596.1600 72040.820 134751.2400 151933.77
Bayshore Elementary 3.0 84482.180000 42568.925091 56680.98 59978.8650 63276.750 98382.7800 133488.81
count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 2.0 192935.720000 13892.965336 183111.91 188023.8150 192935.720 197847.6250 202759.53
Hillsborough City Elementary 4.0 181961.687500 6793.991892 177599.65 178383.8650 179081.245 182659.0675 192084.61
San Mateo Union High 20.0 175506.898500 54568.536111 67855.19 163362.6800 200428.150 211421.2350 227395.26
Las Lomitas Elementary 4.0 164436.650000 26869.977225 128020.65 152222.7675 172468.990 184682.8725 184787.97
Burlingame Elementary 7.0 149433.510000 11250.878350 128525.62 144848.5350 154000.130 156008.3250 161795.10
Menlo Park City Elementary 9.0 140548.274444 34605.796984 86070.57 127400.9000 145263.680 169302.0400 183210.11
San Mateo-Foster City 36.0 138225.527500 45349.357500 3285.24 145835.8125 158053.275 163028.5125 174324.86
Belmont-Redwood Shores Elementary 8.0 131485.196250 29955.858061 62544.65 126116.7450 143240.910 149182.8700 153683.36
Pacifica School District 9.0 125850.023333 32904.557270 65012.77 113410.8200 138542.960 152575.9800 155341.13
Redwood City Elementary 31.0 124817.774839 40927.404876 21101.95 120327.9500 143169.990 155383.4400 159127.20
San Carlos Elementary 7.0 118769.937143 4486.343013 113406.66 116481.8200 117762.960 119962.9800 127330.34
Ravenswood City Elementary 11.0 118305.489091 27519.672571 64941.02 117154.1600 125356.900 135208.8850 148081.73
La Honda-Pescadero Unified 3.0 107645.756667 7726.013211 100878.14 103436.8700 105995.600 111029.5650 116063.53
Jefferson Elementary 21.0 107515.226667 41456.610446 28272.93 67263.1800 129369.740 140453.2100 153024.44
Jefferson Union High 16.0 103082.457500 47325.805624 18125.38 53597.0000 121242.095 140928.4550 162275.45
San Bruno Park Elementary 8.0 100421.731250 13315.892706 75014.08 98724.3300 103920.205 105636.3725 118816.79
Millbrae Elementary 10.0 78460.969000 55483.906718 328.69 42268.7625 70924.395 133340.2750 145329.18
Brisbane Elementary 4.0 58654.617500 48871.706135 2191.88 34216.5425 56474.425 80912.5000 119477.74
count mean std min 25% 50% 75% max
Agency
San Mateo Union High 21.0 168199.121429 32821.681820 65133.59 164292.4000 178442.240 186531.4600 200312.54
Menlo Park City Elementary 7.0 165191.727143 19268.276390 143425.06 147228.3300 168641.040 180493.4300 188832.47
Las Lomitas Elementary 4.0 153098.130000 27567.402937 115571.82 141206.6550 159869.400 171760.8750 177081.90
Woodside Elementary 1.0 148332.620000 NaN 148332.62 148332.6200 148332.620 148332.6200 148332.62
Portola Valley Elementary 2.0 138273.290000 69583.139788 89070.58 113671.9350 138273.290 162874.6450 187476.00
San Mateo-Foster City 28.0 136210.376429 28504.820255 58301.25 134838.6900 148070.410 152265.9400 161376.83
Hillsborough City Elementary 6.0 136141.046667 43468.461304 82671.33 97315.2425 150507.790 165350.6250 183276.74
Pacifica School District 8.0 128275.500000 16281.787198 92122.77 124121.8850 132992.985 137476.8550 143420.10
San Carlos Elementary 6.0 124083.725000 29714.424867 63894.75 132580.8100 134533.980 136329.6200 142681.72
Burlingame Elementary 7.0 120261.875714 40205.770558 57829.58 97795.4450 144861.110 147052.1000 149447.35
Jefferson Union High 13.0 117395.471538 14348.549041 99867.86 105577.6500 118748.800 126963.1200 144346.76
Sequoia Union High 9.0 116424.277778 74029.746402 5816.90 67236.3900 97787.970 187083.7100 194906.81
South San Francisco Unified 24.0 116022.597083 21851.801554 54590.37 115257.2450 120079.995 126962.6825 149048.35
Redwood City Elementary 29.0 115146.415517 32121.290226 35858.30 98419.6100 124656.180 143859.6100 146224.08
Bayshore Elementary 2.0 114167.580000 1071.691038 113409.78 113788.6800 114167.580 114546.4800 114925.38
Jefferson Elementary 18.0 112871.017222 20143.728037 50362.61 110165.3650 120485.660 124816.5725 132074.02
Ravenswood City Elementary 10.0 106144.060000 29023.639506 59757.63 86772.7625 113974.130 126331.1825 138216.70
Belmont-Redwood Shores Elementary 11.0 104733.762727 33894.990068 66349.20 75004.3350 99767.030 138830.3100 148824.88
Cabrillo Unified 12.0 99055.687500 52119.047418 142.86 53397.7325 128833.920 137324.0850 146711.31
Millbrae Elementary 6.0 97533.555000 47175.443680 30219.41 63645.0600 125162.560 128733.3050 131594.02
La Honda-Pescadero Unified 2.0 89011.255000 705.897629 88512.11 88761.6825 89011.255 89260.8275 89510.40
Brisbane Elementary 2.0 66866.525000 66794.756120 19635.50 43251.0125 66866.525 90482.0375 114097.55
count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 2.0 185965.170000 4859.930765 182528.68 184246.9250 185965.170 187683.4150 189401.66
San Mateo Union High 21.0 171357.172381 24137.915028 85650.28 163663.3100 177780.590 185413.5300 199114.42
Sequoia Union High 5.0 162846.766000 41521.194279 89080.97 175640.3000 178703.050 182101.4500 188708.06
Woodside Elementary 1.0 138713.160000 NaN 138713.16 138713.1600 138713.160 138713.1600 138713.16
Menlo Park City Elementary 7.0 126984.090000 34089.877175 77499.89 108304.2450 128353.260 147440.3200 171546.35
San Carlos Elementary 6.0 126075.578333 7312.113846 117097.57 122271.8700 125695.415 127506.1150 138724.70
Hillsborough City Elementary 6.0 116935.461667 49368.911092 60812.68 74829.1700 122644.730 160847.4650 163038.27
Millbrae Elementary 6.0 115742.036667 29603.364270 57249.90 116642.1450 128789.080 132284.2250 133581.72
Belmont-Redwood Shores Elementary 9.0 115626.123333 42328.176668 57996.80 75857.4000 135153.400 155856.3400 164687.35
Burlingame Elementary 7.0 115606.782857 40375.527838 53570.02 98662.9900 138601.410 139275.3000 141199.47
Ravenswood City Elementary 6.0 112550.943333 9433.165463 99067.27 106628.4975 112994.965 120048.8975 123341.91
Jefferson Elementary 17.0 109816.389412 20418.381634 37805.39 110570.2200 113140.540 121400.8900 124278.10
Bayshore Elementary 2.0 108843.265000 1063.594665 108091.19 108467.2275 108843.265 109219.3025 109595.34
South San Francisco Unified 23.0 106135.825652 28851.977980 47001.41 97468.8300 115824.620 125737.2050 143237.78
San Mateo-Foster City 28.0 101538.892500 29681.836713 34513.53 92152.3575 116813.640 120795.8325 128937.88
Las Lomitas Elementary 6.0 91682.333333 56234.660462 16877.43 61414.7275 81043.160 133932.0075 164696.71
La Honda-Pescadero Unified 3.0 85649.660000 23384.410704 60445.45 75153.6250 89861.800 98251.7650 106641.73
Jefferson Union High 20.0 78079.147500 27395.528533 40831.75 55991.7750 69575.035 103436.7450 117224.65